USE [CMS]
GO

/****** Object:  View [dbo].[VW_Hours]    Script Date: 01/01/2013 15:12:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[VW_Hours]
AS
SELECT     dbo.Users.USR_NAME, dbo.Hours.ADM_ID, dbo.Hours.HRS_ID, dbo.Hours.USR_ID, dbo.Hours.HRS_COMPANYNAME, dbo.Hours.HRS_WORKDAY, dbo.Hours.HRS_PAYDAY, 
                      dbo.Hours.HRS_HOURS, dbo.Hours.HRS_COMMENTS, dbo.Hours.MUT_DELETED, dbo.Hours.HRS_DATE
FROM         dbo.Hours LEFT OUTER JOIN
                      dbo.Users ON dbo.Hours.USR_ID = dbo.Users.USR_ID
WHERE     (dbo.Hours.MUT_DELETED IS NULL)

GO
